prepare('SELECT * FROM category WHERE sn =:uid');
$stmt_edit->execute(array(':uid'=>$id));
$edit_row = $stmt_edit->fetch(PDO::FETCH_ASSOC);
extract($edit_row);
}
else
{
header("Location: index.php");
}
if(isset($_POST['btn_save_updates']))
{
$iname = $_POST['name'];
if(isset($_GET['edit_id']) && !empty($_GET['edit_id']))
{
$id = $_GET['edit_id'];
$stmt = $DB_con->prepare('UPDATE category SET category_name=:itc where sn =:uid' );
//$stmt->bindParam(':uname',$username);
$stmt->bindParam(':itc',$iname);
$stmt->bindParam(':uid',$id);
if($stmt->execute()){
?>
Edit Category Records